DROP TABLE IF EXISTS jms_ods.tab_platform_effect_config ;
CREATE EXTERNAL TABLE jms_ods.tab_platform_effect_config (
     START_PROVINCE        string            comment       '始发省份'   ,     --NVARCHAR2(20)
     START_CITY        string            comment       '始发城市'   ,     --NVARCHAR2(20)
     END_PROVINCE        string            comment       '目的省份'   ,     --NVARCHAR2(20)
     END_CITY        string            comment       '目的城市'   ,     --NVARCHAR2(20)
     PLATFORM_EFFECT        bigint            comment       '平台时效'   ,     --NUMBER(10)
     EFFECT_START_TIME        timestamp            comment       '有效开始时间'   ,     --DATE
     EFFECT_END_TIME        timestamp            comment       '有效结束时间'   ,     --DATE
     CREATE_DATE        timestamp            comment       '创建时间'   ,     --DATE
     UPDATE_DATE        timestamp            comment       '更新时间'       --DATE
)
    COMMENT  '平台时效配置(快照表)'
    PARTITIONED BY (dt STRING COMMENT '时间分区')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_ods.db/external/tab_platform_effect_config'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );

MSCK REPAIR TABLE jms_ods.tab_platform_effect_config;
